package com.xr.blog.dao;

import com.xr.blog.pojo.BlogLog;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.springframework.stereotype.Repository;

import java.util.List;
import java.util.Map;

/**
 * 日志表
 * 
 * @author XRJ
 * @email 1033835209@qq.com
 * @date 2020-07-07 20:31:38
 */
@Repository
public interface BlogLogMapper extends BaseMapper<BlogLog> {

    /**
     * 查询所有浏览器
     * @return
     */
    List<String> selectAllBrowser();


    /**
     * 查询所有操作系统
     * @return
     */
    List<String> selectAllOperatingSystem();

    /**
     * 统计访问最多的十个城市
     * @return
     */
    List<Map<String,Integer>> selectCityCount();

    /**
     * 查询最新的日志
     * @return
     */
    List<BlogLog> selectLatestLog(Integer number);
	
}
